CREATE TABLE [OrgType](
	orgTypeID int IDENTITY,
	description varchar(50) NOT NULL,
	PRIMARY KEY (orgTypeID)
)

CREATE TABLE [Organization](
	orgID int IDENTITY,
	name varchar(50) NOT NULL,
	residence varchar(50) NOT NULL,
	zipCode varchar(50) NOT NULL,
	city varchar(50) NOT NULL,
	contact varchar(50) NOT NULL,
	email varchar(50) NOT NULL,
	orgTypeID int NOT NULL, 
	PRIMARY KEY (orgID),
	FOREIGN KEY (orgTypeID) REFERENCES [OrgType](orgTypeID)
)

CREATE TABLE [OrgUser](
	orgUserID int IDENTITY,
	orgID int NOT NULL,
	userID int NOT NULL,
	PRIMARY KEY (orgUserID),
	FOREIGN KEY (orgID) REFERENCES [Organization](orgID),
	FOREIGN KEY (userID) REFERENCES [User](userID)   
)